Node / ReticulumProjects / MeshChatX.git / files / meshchatx / src / backend / database / crash_history.py

Displaying Raw • Download

Tff7b72import T7ee787json

Tff7b72from T7ee787.T7ee787provider Tff7b72import Te6edf3DatabaseProvider

Tff7b72class T56d364CrashHistoryDAOTb4b4b4:

Tff7b72def Tff7b72__init__Tb4b4b4(Tff7b72selfTb4b4b4, Te6edf3providerTb4b4b4: Te6edf3DatabaseProviderTb4b4b4)Tb4b4b4:

Tff7b72selfTff7b72.Td2a8ffprovider Tff7b72= Te6edf3provider

Tff7b72def Td2a8ffinsert_crashTb4b4b4(

Tff7b72selfTb4b4b4,

Te6edf3timestampTb4b4b4,

Te6edf3error_typeTb4b4b4,

Te6edf3error_messageTb4b4b4,

Te6edf3diagnosed_causeTb4b4b4,

Te6edf3symptomsTb4b4b4,

Te6edf3probabilityTb4b4b4,

Te6edf3entropyTb4b4b4,

Te6edf3divergenceTb4b4b4,

Tb4b4b4)Tb4b4b4:

Tff7b72selfTff7b72.Td2a8ffproviderTff7b72.Td2a8ffexecuteTb4b4b4(

T8b949e"""

INSERT INTO crash_history

(timestamp, error_type, error_message, diagnosed_cause,

symptoms, probability, entropy, divergence)

VALUES (?, ?, ?, ?, ?, ?, ?, ?)

"""Tb4b4b4,

Tb4b4b4(

Te6edf3timestampTb4b4b4,

Te6edf3error_typeTb4b4b4,

Te6edf3error_messageTb4b4b4[Tb4b4b4:T79c0ff500Tb4b4b4] Tff7b72if Te6edf3error_message Tff7b72else Tff7b72NoneTb4b4b4,

Te6edf3diagnosed_causeTb4b4b4,

Te6edf3jsonTff7b72.Td2a8ffdumpsTb4b4b4(Te6edf3symptomsTb4b4b4) Tff7b72if Tffa657isinstanceTb4b4b4(Te6edf3symptomsTb4b4b4, Tffa657dictTb4b4b4) Tff7b72else Te6edf3symptomsTb4b4b4,

Te6edf3probabilityTb4b4b4,

Te6edf3entropyTb4b4b4,

Te6edf3divergenceTb4b4b4,

Tb4b4b4)Tb4b4b4,

Tb4b4b4)

Tff7b72def Td2a8ffget_recent_crashesTb4b4b4(Tff7b72selfTb4b4b4, Te6edf3limitTff7b72=T79c0ff50Tb4b4b4)Tb4b4b4:

Tff7b72return Tff7b72selfTff7b72.Td2a8ffproviderTff7b72.Td2a8fffetchallTb4b4b4(

Ta5d6ff"Ta5d6ffSELECT * FROM crash_history ORDER BY timestamp DESC LIMIT ?Ta5d6ff"Tb4b4b4,

Tb4b4b4(Te6edf3limitTb4b4b4,Tb4b4b4)Tb4b4b4,

Tb4b4b4)

Tff7b72def Td2a8ffget_cause_frequenciesTb4b4b4(Tff7b72selfTb4b4b4, Te6edf3limitTff7b72=T79c0ff50Tb4b4b4)Tb4b4b4:

Tff7b72return Tff7b72selfTff7b72.Td2a8ffproviderTff7b72.Td2a8fffetchallTb4b4b4(

T8b949e"""

SELECT diagnosed_cause, COUNT(*) as count

FROM (SELECT * FROM crash_history ORDER BY timestamp DESC LIMIT ?)

GROUP BY diagnosed_cause

ORDER BY count DESC

"""Tb4b4b4,

Tb4b4b4(Te6edf3limitTb4b4b4,Tb4b4b4)Tb4b4b4,

Tb4b4b4)

Tff7b72def Td2a8ffcleanup_oldTb4b4b4(Tff7b72selfTb4b4b4, Te6edf3max_entriesTff7b72=T79c0ff200Tb4b4b4)Tb4b4b4:

Tff7b72selfTff7b72.Td2a8ffproviderTff7b72.Td2a8ffexecuteTb4b4b4(

T8b949e"""

DELETE FROM crash_history WHERE id NOT IN (

SELECT id FROM crash_history ORDER BY timestamp DESC LIMIT ?

)

"""Tb4b4b4,

Tb4b4b4(Te6edf3max_entriesTb4b4b4,Tb4b4b4)Tb4b4b4,

Tb4b4b4)